
if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_Order') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_Order
END
GO
	CREATE VIEW V_Order
	AS 
	SELECT  A.Guid, A.MemLoginID, A.OrderNumber,A.OderStatus,A.ShipmentStatus,A.PaymentStatus,
			A.Name,A.Email,A.[Address],A.Postalcode,A.Tel,A.Mobile,A.ClientToSellerMsg,
			A.DispatchModeGuid,A.PaymentGuid,A.PackGuid,A.BlessCardGuid,A.OutOfStockOperate,
			A.InvoiceTitle,A.InvoiceContent,A.ProductPrice,A.DispatchPrice,A.InsurePrice,
			A.PaymentPrice,A.PackPrice,A.BlessCardPrice,A.AlreadPayPrice,A.SurplusPrice,A.UseScore,A.ScorePrice,A.ShouldPayPrice,
			A.CreateTime,A.ConfirmTime,A.PayTime,A.DispatchTime,A.ShipmentNumber,A.PayMemo,
			A.ActivityGuid,A.InvoiceType,A.InvoiceTax,A.Discount,A.Deposit,A.IsPayDeposit,
			A.CreateUser,A.ModifyUser,A.ModifyTime,A.RegionCode,
			A.JoinActiveType,A.ActvieContent,A.UsedFavourTicket,A.LogisticsCompanyCode
	FROM ShopNum1_OrderInfo A
  
 